package com.campus.campus.mapper;

import com.campus.campus.job.StaticData;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.campus.campus.job.dto.ElectricityUsageDTO;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

/**
 * <p>
 * 水费或电费消耗记录表 Mapper 接口
 * </p>
 *
 * @author author
 * @since 2024-12-07
 */
public interface StaticDataMapper extends BaseMapper<StaticData> {

    List<ElectricityUsageDTO> getDailyUsageForWeek(@Param("startTime") String startTime,
                                                   @Param("endTime") String endTiame,
                                                   @Param("way")String way,@Param("campusCardId") Integer campusCardId);

    BigDecimal getTotal(@Param("startTime") String startTime,
                        @Param("endTime") String endTiame,
                        @Param("type") String type);
}
